csv-parse

What is csv-parse?

The csv-parse package is a flexible Node.js library that provides a parser converting CSV text input into arrays or objects. It implements the Node.js stream.Transform API. It is also capable of converting large datasets and supports many advanced features such as streaming and asynchronous processing.

What are csv-parse's main functionalities?

Parsing CSV to Arrays

This feature allows you to parse CSV data into arrays. Each row in the CSV data becomes an array.

const parse = require('csv-parse');
const assert = require('assert');
const input = 'a,b,c\nd,e,f';
parse(input, function(err, output){
  assert.deepEqual(output, [['a', 'b', 'c'], ['d', 'e', 'f']]);
});

Parsing CSV with Column Mapping

This feature allows you to map CSV columns to object properties, so each row in the CSV data becomes an object with named properties.

const parse = require('csv-parse');
const assert = require('assert');
const input = 'a,b,c\nd,e,f';
const parser = parse({columns: true}, function(err, records){
  assert.deepEqual(records, [{a: 'd', b: 'e', c: 'f'}]);
});
parser.write(input);
parser.end();

Asynchronous Iteration

This feature allows for asynchronous iteration over the parsed records, which is useful for handling large CSV files or streams.

const parse = require('csv-parse');
const fs = require('fs');
const parser = fs.createReadStream('/path/to/csv-file.csv').pipe(parse({columns: true}));
(async () => {
  for await (const record of parser) {
    // Work with each record
  }
})();

Other packages similar to csv-parse

papaparse

Papa Parse is a powerful CSV parser that can handle large files and malformed input gracefully. It works in both browser and server environments. Compared to csv-parse, Papa Parse has a more user-friendly API and can automatically detect delimiters.

fast-csv

Fast-csv is another CSV parsing and formatting library for Node.js. It provides a simple API and supports both stream and callback-based processing. It is known for its speed and efficiency, but csv-parse offers more advanced features and customization options.

csvtojson

csvtojson is a full-featured CSV parser library that converts CSV to JSON. One of its main differences from csv-parse is that it focuses on the JSON output format, whereas csv-parse provides more flexibility in handling the parsed data.

README

CSV Parser for Node.js

Part of the CSV module, this project is a parser converting CSV text input into arrays or objects. It implements the Node.js stream.Transform API. It also provides a simple callback-based API for convenience. It is both extremely easy to use and powerful. It was first released in 2010 and is used against big data sets by a large community.

Documentation

• Project homepage
• API
• Options
• Info properties
• Common errors
• Examples

Features

• Follow the Node.js streaming API
• Simplicity with the optional callback API
• Support delimiters, quotes, escape characters and comments
• Line breaks discovery
• Support big datasets
• Complete test coverage and samples for inspiration
• No external dependencies
• Work nicely with the csv-generate, stream-transform and csv-stringify packages
• MIT License